<!doctype html>
<html>
<head>
  <meta charset="UTF-8" />
  <title>安装许可协议 - Powered by CRMEB </title>
  <link rel="stylesheet" href="/install/css/install.css?v=9.0" />
</head>
<body>
<div class="wrap">
  <div class="header">
    <h1 class="logo">logo</h1>
    <div class="icon_install">安装向导</div>
    <div class="version"></div>
  </div>
  <section class="section">
    <div class="step">
      <ul>
        <li class="on"><em>1</em>检测环境</li>
        <li class="current"><em>2</em>创建数据</li>
        <li><em>3</em>完成安装</li>
      </ul>
    </div>
    <form id="J_install_form" action="/install/databases/create" method="post">
      <input type="hidden" name="force" value="0" />
      <div class="server">
        <table width="100%">
          <tr>
            <td class="td1" width="100">数据库信息</td>
            <td class="td1" width="200">&nbsp;</td>
            <td class="td1">&nbsp;</td>
          </tr>
          <tr>
            <td class="tar">数据库服务器：</td>
            <td><input type="text" name="dbhost" id="dbhost" value="127.0.0.1" class="input"></td>
            <td><div id="J_install_tip_dbhost"><span class="gray">数据库服务器地址，一般为127.0.0.1</span></div></td>
          </tr>
          <tr>
            <td class="tar">数据库端口：</td>
            <td><input type="text" name="dbport" id="dbport" value="3306" class="input"></td>
            <td><div id="J_install_tip_dbport"><span class="gray">数据库服务器端口，一般为3306</span></div></td>
          </tr>
          <tr>
            <td class="tar">数据库用户名：</td>
            <td><input type="text" name="dbuser" id="dbuser" value="root" class="input"></td>
            <td><div id="J_install_tip_dbuser"></div></td>
          </tr>
          <tr>
            <td class="tar">数据库密码：</td>
            <td><input type="password" name="dbpw" id="dbpw" value="" class="input" autoComplete="off" onBlur="TestDbPwd(0)"></td>
            <td><div id="J_install_tip_dbpw"></div></td>
          </tr>
          <tr>
            <td class="tar">数据库名：</td>
            <td><input type="text" name="dbname" id="dbname" value="crmeb_merchant" class="input" onBlur="TestDbPwd(0)"></td>
            <td><div id="J_install_tip_dbname"></div></td>
          </tr>
          <tr>
            <td class="tar">数据库表前缀：</td>
            <td><input type="text" name="dbprefix" id="dbprefix" value="eb_" class="input" ></td>
            <td><div id="J_install_tip_dbprefix"><span class="gray">建议使用默认，同一数据库安装多个CrmEb时需修改</span></div></td>
          </tr>
          <tr>
            <td class="tar">演示数据：</td>
            <td colspan="2"><input style="width:18px;height:18px;" type="checkbox" id="demo" name="demo" value="demo" checked></td>
          </tr>
        </table>
        <table width="100%">
          <tr>
            <td class="td1" width="100">reids数据库信息</td>
            <td class="td1" width="200">&nbsp;</td>
            <td class="td1">&nbsp;</td>
          </tr>
          <tr>
            <td class="tar">服务器地址：</td>
            <td><input type="text" name="rbhost" id="rbhost" value="127.0.0.1" class="input" onBlur="TestDbPwd(0)"></td>
            <td><div id="J_install_rbhost"><span class="gray">reids服务器地址，一般为127.0.0.1</span></div></td>
          </tr>
          <tr>
            <td class="tar">端口号：</td>
            <td><input type="text" name="rbport" id="rbport" value="6379" class="input" autoComplete="off" onBlur="TestDbPwd(0)"></td>
            <td><div id="J_install_pwd"><span class="gray">reids端口,默认为6379</span></div></td>
          </tr>
          <tr>
            <td class="tar">数据库：</td>
            <td><input type="text" name="rbselect" id="rbselect" value="0" class="input" autoComplete="off"onBlur="TestDbPwd(0)"></td>
            <td><div id="J_install_ckpwd"><span class="gray">reids数据库，默认为0,一般不做更改</span></div></td>
          </tr>
          <tr>
            <td class="tar">密码：</td>
            <td><input type="password" name="rbpw" id="rbpw" value="" class="input" autoComplete="off" onBlur="TestDbPwd(0)"></td>
            <td><div id="J_install_dbpw"></div><span class="gray">reids数据库密码</span></td>
          </tr>

        </table>
        <table width="100%">
          <tr>
            <td class="td1" width="100">管理员信息</td>
            <td class="td1" width="200">&nbsp;</td>
            <td class="td1">&nbsp;</td>
          </tr>
          <tr>
            <td class="tar">管理员帐号：</td>
            <td><input type="text" name="manager" id="manager" value="admin" class="input"></td>
            <td><div id="J_install_tip_manager"></div></td>
          </tr>
          <tr>
            <td class="tar">管理员密码：</td>
            <td><input type="password" name="manager_pwd" id="manager_pwd" class="input" max="16" autoComplete="off"></td>
            <td><div id="J_install_tip_manager_pwd"></div></td>
          </tr>
          <tr>
            <td class="tar">重复密码：</td>
            <td><input type="password" name="manager_ckpwd" id="manager_ckpwd" class="input" max="16" autoComplete="off"></td>
            <td><div id="J_install_tip_manager_ckpwd"></div></td>
          </tr>

        </table>
        <div id="J_response_tips" style="display:none;"></div>
      </div>
      <div class="bottom tac"> <a href="/install/environment" class="btn">上一步</a>
        <button type="button" onClick="checkForm();" class="btn btn_submit J_install_btn">创建数据</button>
      </div>
    </form>
  </section>
  <div  style="width:0;height:0;overflow:hidden;"> <img src="/install/images/install/pop_loading.gif"> </div>
  <script src="/install/js/jquery.js?v=9.0"></script>
  <script src="/install/js/validate.js?v=9.0"></script>
  <script src="/install/js/ajaxForm.js?v=9.0"></script>
  <script>

    function TestDbPwd(connect_db)
    {
      var data={
        'dbhost': $('#dbhost').val(),
        'dbuser': $('#dbuser').val(),
        'dbpw':   $('#dbpw').val(),
        'dbname': $('#dbname').val(),
        'dbport': $('#dbport').val(),
        'demo':   $('#demo').val(),
        'rbhost': $('#rbhost').val(),
        'rbport': $("#rbport").val(),
        'rbselect': $("#rbselect").val(),
        'rbpw':   $('#rbpw').val(),
        'dbprefix':$('#dbprefix').val(),
      };
      var url =  "/install/databases/check";
      $.ajax({
        type: "POST",
        url: url,
        data: data,
        dataType:'JSON',
        beforeSend:function(){
        },
        success: function (msg) {
          if (msg == 1) {

            if (connect_db == 1) {
              $("#J_install_form").submit(); // ajax 验证通过后再提交表单
            }
            $('#J_install_tip_dbpw').html('');
            $('#J_install_tip_dbname').html('');
            $('#J_install_rbhost').html('');
          } else if (msg == -1) {
            $('#J_install_rbhost').html("");
            $('#J_install_tip_dbname').html("");
            $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">请在mysql配置文件修sql-mode或sql_mode为NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION</span>');
          } else if (msg == -2) {
            $('#J_install_rbhost').html("");
            $('#J_install_tip_dbname').html("");
            $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">请在mysql配置文件修sql-mode或sql_mode为 NO_ENGINE_SUBSTITUTION </span>');
          } else if (msg == -3) {
            $('#J_install_rbhost').html("");
            $('#J_install_tip_dbpw').html("");
            $('#J_install_tip_dbname').html('<span for="dbname" generated="true" class="tips_error" style="">你的不是空数据库, 请更换一个数据库名字</span>');
          } else if (msg == -4) {
            $('#J_install_rbhost').html("");
            $('#J_install_tip_dbpw').html("");
            $('#J_install_tip_dbname').html('<span for="dbname" generated="true" class="tips_error" style="">Mysql数据库版本不的低于5.6</span>');
          } else if (msg == -5) {
            $('#J_install_tip_dbname').html("");
            $('#J_install_tip_dbpw').html("");
            $('#J_install_rbhost').html('<span for="dbname" generated="true" class="tips_error" style="">Redis数据库没有启动或者密码错误</span>');
          } else if (msg == -6) {
            $('#J_install_tip_dbname').html("");
            $('#J_install_tip_dbpw').html("");
            $('#J_install_tip_dbprefix').html('<span for="dbname" generated="true" class="tips_error" style="">数据库前缀必须填写</span>');
          }else {
            $('#J_install_tip_dbname').html("");
            $('#J_install_rbhost').html("");
            $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">数据库链接配置失败</span>');
          }
        },
        complete:function(){
        },
        error:function(){
          $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">数据库链接配置失败</span>');
        }
      });
    }



    function checkForm()
    {
      manager = $.trim($('#manager').val());				//用户名表单
      manager_pwd = $.trim($('#manager_pwd').val());		//密码表单
      manager_ckpwd = $.trim($('#manager_ckpwd').val());	//密码提示区

      if(manager.length == 0 ) {
        alert('管理员账号不能为空');
        return false;
      }
      if(manager_pwd.length < 6 ) {
        alert('管理员密码必须大于6位数');
        return false;
      }
      if(manager_pwd.length > 16 ) {
        alert('管理员密码必须小于16位数');
        return false;
      }
      if(manager_ckpwd !=  manager_pwd) {
        alert('两次密码不一致');
        return false;
      }
      TestDbPwd(1);
    }



  </script>
</div>
<div class="footer"> &copy; 2014-2022 <a href="http://www.crmeb.com" target="_blank">www.crmeb.com</a> 西安众邦网络科技有限公司出品</div>
</body>
</html>
